| amLeadSrc |
| Logical Entity Name | amLeadSrc |
| Default Table Name | amLeadSrc |
| Physical Only | NO |
| Definition | |
| Note |
| amLeadSrc Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| Code | char(12) | NO | ||
| Descrip | varchar(40) | NO | ||
amLeadCatID |
int | NO | ||
| SyCampusGrpID | int | NO | ||
| Active | bit | NO | ||
| SystemCode | bit | NO | ||
| ModFlag | char(1) | NO | ||
| UserID | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
amLeadSrcID |
int | NO | ||
| AllowOnline | bit | YES | ||
| CaptureAdInfo | bit | NO | ||
| OverrideDefaultVendor | bit | NO | ||
| CrmSuppressFlag | bit | NO |
| amLeadSrc Primary and Unique Keys |
| Key Name | Key Type | Keys |
| amLeadSrc_amLeadSrcID_U_C_IDX | PrimaryKey | amLeadSrcID |
| amLeadSrc Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| amLeadCat | Non-Identifying | One To Zero or More | FK_amLeadSrcAmLeadCatId_amLeadCatAmLeadCatId | amLeadCatID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| amLeadSrcExternalMap | Non-Identifying | One To Zero or More | FK_amLeadSrcExternalMapamLeadSrcId_amLeadSrcamLeadSrcId | NO | YES | |||
| AmLeadSrcLeadVendor | Non-Identifying | One To Zero or More | FK_AmLeadSrcLeadVendor_AmLeadSrcID_AmLeadSrc_AmLeadSrcID | NO | YES | |||
| syStudent | Non-Identifying | One To Zero or More | FK_syStudent_AmLeadSrcID_AmLeadSrc_AmLeadSrcID | NO | YES | |||
| SyStudentInquiry | Non-Identifying | One To Zero or More | FK_SyStudentInquiry_AmLeadSrcID_AmLeadSrc_AmLeadSrcID | NO | YES |
| amLeadSrc Check Constraints |
| Check Constraint Name | CheckConstraint |